MS Access File

You can import metadata from MS Access files into a MS Access environment.

To import metadata from MS Access files, follow these steps:

  1. In the Data Catalog pane, right-click a MS Access environment.

  2. Click Scan Metadata.

    3. The MS Access Metadata Scan - Step1 page appears.

  3. Drag and drop or use to browse and select the MS Access file.
  4. Use the following scan options:
    Add New
    Use this option to insert new metadata into the environment.
    Update Existing + Add New
    Use this option to update the existing metadata based on tables and columns in the MS Access file.
    Update Existing + Add New + Invalidate
    Use this option to update the existing metadata without deleting it.
    Delete & Reload
    Use this option to delete all the business properties and data dictionary stored as metadata for this environment.
  5. Click .

    6. The MS Access Metadata Scan - Step2 page appears.

  6. Select the required tables.
  7. Click .

    8. The metadata is imported and saved in the environment.